Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
SupplierID (FK)(PK) | A unique system assigned identifier for the Supplier. | ID_SPR | Identity | integer | Supplier(PA_SPR) |
RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | RetailStore(PA_STR_RTL) |
PriceZoneCode | A code to signify the pricing policy for a specific geographic zone | LU_ZN_PR | Code4 | char(4) | |
PromotionalZoneCode | A code to signify the pricing promotion policy for a specific geographic zone | LU_ZN_PRM | Code4 | char(4) | |
FreightZoneCode | A code to signify the freight charges to retail stores within a specific geographic zone | LU_ZN_SPR_FRGT | Code4 | char(4) | |